/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : lcode_editor

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 24/09/2022 18:17:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lcode_project
-- ----------------------------
DROP TABLE IF EXISTS `lcode_project`;
CREATE TABLE `lcode_project` (
  `id` varchar(50) COLLATE utf8mb4_bin NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `platform` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL,
  `desc` varchar(500) COLLATE utf8mb4_bin DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `basis` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT 'vue3',
  `configs` text COLLATE utf8mb4_bin,
  `created_user` int(10) DEFAULT '0',
  `updated_user` int(10) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of lcode_project
-- ----------------------------
BEGIN;
INSERT INTO `lcode_project` VALUES ('02edab94', 'ecommerce_h5', 'h5', '商城h5', 1, 'vue3', '{\"id\":\"app_02edab94\",\"name\":\"ecommerce_h5\",\"type\":\"app\",\"items\":[{\"id\":\"page_06c8830f\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"首页\",\"items\":[{\"id\":\"h5-swipe_969f1c14\",\"type\":\"h5-swipe\",\"style\":{\"width\":\"100%\",\"position\":\"absolute\",\"top\":\"\",\"left\":\"\",\"right\":\"\",\"bottom\":\"\",\"height\":\"160\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"swipe\",\"loop\":true,\"autoplay\":2000,\"duration\":1000,\"initialSwipe\":0,\"showIndicators\":true,\"indicatorColor\":\"#ccc\",\"events\":[],\"created\":\"\"},{\"id\":\"h5-list_50f9f010\",\"type\":\"h5-list\",\"style\":{\"width\":\"100%\",\"height\":\"500\",\"position\":\"absolute\",\"top\":\"160\",\"left\":\"\",\"right\":\"\",\"bottom\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"list\",\"loading\":true,\"error\":false,\"finished\":false,\"offset\":300,\"loadingText\":\"加载中\",\"finishedText\":\"加载完成\",\"errorText\":\"加载失败\",\"events\":[],\"created\":\"\"}],\"events\":[],\"created\":\"\"},{\"id\":\"page_530129b1\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"分类\",\"items\":[],\"events\":[],\"created\":\"\"},{\"id\":\"page_317cbe57\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"购物车\",\"items\":[],\"events\":[],\"created\":\"\"},{\"id\":\"page_1ac780fa\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"我的\",\"items\":[],\"events\":[],\"created\":\"\"}]}', 0, 0, '2022-09-20 21:35:11', '2022-09-20 21:35:11');
INSERT INTO `lcode_project` VALUES ('5a8d6c40', 'ecommerce_web', 'web', '商城web', 1, 'vue3', '{\"id\":\"app_5a8d6c40\",\"name\":\"ecommerce_web\",\"type\":\"app\",\"items\":[{\"id\":\"page_96669ca6\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"首页\",\"items\":[{\"id\":\"web-table_d481a61b\",\"type\":\"web-table\",\"style\":{\"width\":\"100%\",\"height\":\"500\",\"position\":\"absolute\",\"top\":\"\",\"left\":\"\",\"right\":\"\",\"bottom\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"table\",\"stripe\":false,\"border\":true,\"size\":\"default\",\"fit\":true,\"showHeader\":true,\"highlightCurrentRow\":true,\"emptyText\":\"现在还没有数据\",\"events\":[],\"created\":\"\"}],\"events\":[],\"created\":\"\"},{\"id\":\"page_2fd1f4f0\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"商品管理\",\"items\":[],\"events\":[],\"created\":\"\"},{\"id\":\"page_4979ef00\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"订单管理\",\"items\":[],\"events\":[],\"created\":\"\"},{\"id\":\"page_564027f6\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"会员管理\",\"items\":[],\"events\":[],\"created\":\"\"},{\"id\":\"page_e845657c\",\"type\":\"page\",\"layout\":\"absolute\",\"style\":{\"position\":\"relative\",\"top\":0,\"left\":0,\"right\":\"\",\"bottom\":\"\",\"width\":\"\",\"height\":\"\",\"backgroundImage\":\"\",\"backgroundColor\":\"\",\"backgroundRepeat\":\"no-repeat\",\"backgroundSize\":\"100% 100%\",\"color\":\"\",\"fontSize\":\"\",\"fontWeight\":\"\",\"transform\":{\"rotate\":\"\",\"scale\":\"\"}},\"name\":\"营销管理\",\"items\":[],\"events\":[],\"created\":\"\"}]}', 0, 0, '2022-09-20 21:35:53', '2022-09-20 21:35:53');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
